How to Highlight Every Third Row in Microsoft Excel ...

Is there a way to specify that I want the conditional formatting to apply to every 3rd row in every third column?

To highlight rows in groups of n (ie shade every 3 rows, every 5 rows, etc.) you can apply conditional formatting with a formula based on the ROW, CEILING ...

1. Select the data range that you want to highlight every nth row. · 2. Click Home > Conditional Formatting > New Rule, see screenshot: · 3. · 4.

Select the range of cells that you want to format. · Go to Home > Format as Table. · Pick a table style that has alternate row shading.

Use the steps in this tutorial to highlight every other row in Excel using conditional formatting. You can extend this to highlight every nth row/column.

While holding the Ctrl key, click on every other row or on every nth row. Release the Ctrl key, and you will have selected the desired rows.

Highlight every other row or column by applying Table style · Click Home > Format as Table, and then choose a table style that has alternate row ...

I would like to alternate colors every three rows, so instead of every other row being a color, I would like every three rows to be a color.

Thanks to @harsinchh4342 for your #ViewerQuestion about how to highlight every 3rd row in Microsoft Excel and Google Sheets.

Conditional Formatting in Excel allows you to highlight every 2nd, 3rd, 4th, or 5th row. Writing a formula using the MOD function and ROW ...